Skip to main content

WINDOW SORT PUSHED RANK

Short Description

Analytical functions are in use and a RANK has been specified.

Detailed Description​

A PUSHED RANK is the analytical equivalent of a SORT ORDER BY STOPKEY and is being used within an OVER () call.

Analytical calls can be very useful, but as not everyone understands them, watch out for maintainability and as always - test to ensure they minimise machine load and execution time.

For example:

SELECT * FROM
   ( SELECT spmnt, totalamount, upmnt,
      **RANK()** OVER (PARTITION BY upmnt ORDER BY totalamount DESC) "RANKING"
     FROM orders
   ) WHERE **RANKING** <= 5;

Further Reading​

Search online​

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.